Create “Time” Chart 14

Step 1: Create “Time” Chart


                a. Double click on the “Line and Stacked column Chart" On the visualization bar.

                b. Chart visual will display on the report.

    c. Adds the fields to the Values well on the visualization bar

·         Drag and drop the "Month" column from the Calendar table on the Shared axis.

·         Drag and drop the "Year" column from the Calendar table on the Shared axis.

·         Drag and drop the "Weekdays" column from the Calendar table on the Shared axis

·         Drag and drop the "Holiday " column from the Holiday table on the Shared axis.

·         Drag and drop the “Sex" column from the DUI_Fatalities table on the Column Series.

·         Drag and drop the “Accident Per Day” column from the DUI_Fatalities table on the Column Values.

·         Drag and drop the “. YOY and %Fatalities " column from the DUI_Fatalities table on the Line Values.

 

 

Follow the gif below to create the “Time chart”. 


Step 2: Configure “Time” chart

             Click on the Format icon on the visualization bar

a. Click General Tab

·         Responsive: On

·         X- Position: 180

·         Y Position:  116

·         Width: 586

·         Height: 315

·         Legend: ON

·         position: Top

·         Title: OFF

·         Circle Default Icon: on

Follow the gif below to format the “Time chart”.



b. Configure the X axis:

·         Color: Black 

·         Text Size: 9

·         Font family: Segue UI

·         Minimum Catalogues width: 38%

·         Maximum size Categories :33%

·         Inner padding: 21 %

·         Concatenate labels:  ON

·         Title: OFF


Follow the gif below to format the X axis  “Time chart”.


c. Configure the Y- axis

 

a.    Y-axis (Column)

·         Position: Left

·         Scale type: Liner

·         Start: -30

·         End: 140

·         Invert axis: Off

·         Color: Black

·         Text Size: 9

·         Font Family:  Segoe UI

·         Display: Auto

·         Value Decimal Place: Auto

·         Title: OFF

·         Gride Line: On

·         Line Color: Black (666666)

·         Stroke Width: 1

·         Line Style: Dotted

·         Show Secondary: ON

·         Align Zero: ON

 

b.    Y- axis (Line)

·         Position: Right

·         Start: Auto

·         End: 0.3

·         Scala type: Liner

·         Color: FF8900

·         Text Size: 9

·         Font Family: Segoe Ul

·         Display unit: Auto

                       

Follow the gif below to format the Y- axis “Time chart”.


 

                                         d.  Configure Data Color:

·         YOY: FF8900

·         % Fatalities: 6EB7E4

·         Female: EB00EB

·         Male: 262A7


Follow the gif below to format the Data Color:


e.  Configure Data Label: ON

·         Color: White (FFFFF)

·         Display Unite: None

·         Value Decimal: 1

·         Orientation: Horizontal

·         Position: Auto

·         Text Size: 9

·         Font Family: Arial

·         Show Background: ON

·          Color :123D8F

·         Transparency: 53%

·         Customize Serious ON

·         Select “Female”

·         Show:  ON

·         Color: White

·         Display: None

·         Value Decima Place: 1

·         Position: Auto

·         Text Size: 9

·         Font Family: Arial

·         Show Background: ON

·         Background Color: 123D8F

·         Transparency: 53%

·         Total Label: OFF

·         Title: ON  

 

 

    Follow the gif below to format the Data Label  “Time chart”.


f. Configure Shape, Title, Background and Boarder

a. Shape

·         Shaded area: ON

·         Stroke Width: 1

·         Joint type: Bevel

·         Line Style: Solid

·         Show Maker: OFF

·         Custom Series: OFF

·         Plot Area Transparency: 0%

                                      b. Title: ON

·         Type: “Time”

·         Word Wrap: ON

·         Font Color: Black

·         Background Color: ACD0E7

·         Alignment: Left

·         Text Size: 17

·         Font Family: DIN

                                       c. Background: ON

·         Background: white

·         Transparency: 15%

  d. Border: ON

·         Color: White 10% darker

 

Follow the gif below to format the shape, Title, Background and Boarder “Time Chart”.





To learn More about Line and Stacked column charts, click the link below:

https://www.tutorialgateway.org/line-and-stacked-column-chart-in-power-bi/